Introduction to PHP and MySQL

Learn how to create an interactive Web site, allowing visitors to post and retrieve information provided by you or your site's visitors. In this six-week online course, you'll see how to create dynamic Web pages using the PHP programming language and the MySQL database server.

During the course, you'll walk through the development of a complete content management system Web application. You'll receive clear, step-by-step, instructions demonstrating how to create a complete Web site capable of dynamically displaying data from a MySQL database.

You'll discover how you can allow your site's visitors to add new information to an online database, search through posted data, and create meaningful printed reports. By the end of this course, you'll have plenty of useful code templates that will help you create your very own dynamic, Web-based, content management system.

This course includes a knowledgeable and caring instructor who will guide you through your lessons, facilitate discussions, and answer your questions. The instructor for this course will be Richard Blum.

Richard Blum has been an IT industry professional for over 18 years, working mainly as a network and systems administrator. During this time, he has worked with Microsoft, Novell, Unix, and Linux servers, and has created Web sites using a variety of different programming languages. Blum is the author of several programming and systems administration books, including Professional Assembly Language, C# Network Programming, PostgreSQL 8 for Windows, Sendmail for Linux, Postfix, and Network Performance Open Source Toolkit.

Or, click the Enroll Now button below:

Requirements:

A PHP and MySQL development environment. During the first lesson in the course, you will be walked through the process of installing WAMP5 software, which provides a full PHP and MySQL development environment. You can download WAMP5 for free from http://www.wampserver.com/en/. You will also need Windows NT, Windows 2000, Windows XP, or Windows Vista (WAMP5 does not support either Windows 98 or Windows Me); Internet access, e-mail, the Microsoft Internet Explorer or Mozilla Firefox Web browser, and the Adobe Flash and PDF plug-ins (two free and simple downloads you obtain at http://www.adobe.com/downloads by clicking Get Adobe Flash Player and Get Adobe Reader). Note: Macintosh users will not be able to use the WAMP5 software, and must provide their own PHP and MySQL development environment. Prior HTML coding experience is helpful, but not required.

Syllabus:

A new section of each course starts monthly. If enrolling in a series of two or more courses, please be sure to space the start date for each course at least two months apart.

All courses run for six weeks, with a two-week grace period at the end. Two lessons are released each week for the six-week duration of the course. You do not have to be present when lessons are released. You will have access to all lessons until the course ends. However, the interactive discussion area that accompanies each lesson will automatically close two weeks after the lesson is released. As such, we strongly recommend that you complete each lesson within two weeks of its release.

The final exam will be released on the same day as the last lesson. Once the final exam has been released, you will have two weeks to complete all of your course work, including the final exam.

Week One

Wednesday - Lesson 01

These days, people expect the information on professional Web sites to change continually and to remain up to date—even up to the minute. In this lesson, you'll start learning how to produce dynamic Web pages that can do just that. We'll begin exploring the Web application we'll be building throughout the course—one that will result in a complete content management system that you can adapt for any future Web sites you create. You'll see how the PHP programming language presents dynamic data, and how the MySQL database server stores it. We'll also dive into the world of WAMP servers, the engine behind dynamic Web sites. Finally, you'll take a big (but easy) step forward by downloading and installing a WAMP server on your own computer.

Friday - Lesson 02

PHP has taken the Web by storm, and there are now literally thousands of sites that use it to give visitors a dynamic experience. Today, we'll look behind the curtain of these Web sites so you can see how you can use PHP in your own applications. We'll examine the basic structure of the language, and you'll discover how easy it is to start programming with it.

Week Two

Wednesday - Lesson 03

The core of any dynamic Web site is its database engine. The WAMP server we're working with uses the popular MySQL database server to store data. In this lesson, you'll find out how to work with it to provide the content for your application. We'll examine what database elements are required to store and access data, and then we'll implement them using the graphical phpMyAdmin program. You'll learn how to create databases, data tables, and a user account.

Friday - Lesson 04

Throughout this course, we'll be creating a dynamic Recipe Center Web application. It will allow visitors to post new recipes as well as view existing recipes and post comments about them. This will be a fun, interactive way to learn how to use PHP and MySQL. It will also result in a template you can use to build any other dynamic Web applications you want. Today, we'll look at the elements you'll need for the Recipe Center application, and we'll map out a strategy for creating the final product. We'll start by building the center of the application—the home page. From there, your visitors will be able to view a list of recipes, see the latest site news, and navigate to all of the site's other sections.

Week Three

Wednesday - Lesson 05

In this lesson, using your newfound PHP programming skills and your newly created MySQL database, we'll actually start displaying recipes in the Recipe Center application. You'll see how PHP-included files can help keep your programming code simple. And you'll find out how PHP can help you create dynamic links on your Web pages—links that change along with the data on the pages.

Friday - Lesson 06

From simple guest books to complicated interactive discussion areas, allowing visitors to post data on a Web site has become commonplace. Today, you'll see how PHP can extract data from simple HTML forms and store it in your MySQL database. Then we'll use this feature to allow visitors to post comments and new recipes in the Recipe Center application.

Week Four

Wednesday - Lesson 07

These days, users expect Web sites to provide data-searching features. So in this lesson, we'll focus on incorporating searching into the Recipe Center application. We'll examine some common searching algorithms, and we'll go over the SQL tricks and PHP coding you'll need to know to implement them.

Friday - Lesson 08

While some people would like to live in a paperless society, many still find it necessary to print everything. But trying to print data from a dynamic Web site is often challenging. Fortunately, today you'll discover what you can do to make printing simpler for your Web site visitors. We'll go over two different techniques you can incorporate into your Web applications to let visitors print exactly what they need. Then we'll implement both of them into the Recipe Center application so you can see them in action.

Week Five

Wednesday - Lesson 09

Just saying the word security can send Web administrators into a frenzy. But any dynamic Web site that allows visitors to post data needs to have some level of security. In this lesson, we'll look at what you can do to protect your Recipe Center application from vandals and comment spammers. You'll see how to use PHP to control who can post items, and we'll create a log-in system for the application that tracks logged-in visitors as they request services.

Friday - Lesson 10

Unfortunately, bad things can happen to data that's on the Web, and it's your job to be prepared for the worst. Today, we'll walk through the options for protecting your data from a catastrophe. We'll discuss how to use data backups to help minimize any data loss, and you'll see how to backup the MySQL server data to safely store information in case your server crashes. Finally, we'll look at how to use the simple phpMyAdmin utility to export your data at a moment's notice—even while your visitors are still busily working away in the application.

Week Six

Wednesday - Lesson 11

Sometimes you can have too much data on a Web page. There's nothing worse than dumping thousands of data records onto your users' screens and making them sort through all of it. In this lesson, you'll learn about a user-friendly way to handle massive amounts of data. It's called paging, and commercial search engines like Google and Yahoo popularized it. We'll take a peek at how they use paging, and then we'll apply their techniques to the Recipe Center application.

Friday - Lesson 12

One problem with dynamic Web pages is that there are lots of code files to keep track of. For a large application, you can easily lose track of which files have been modified or which versions of files are active. In our final lesson, you'll learn how to organize your PHP programming environment using software version control packages. We'll walk through the process of using a simple version control system to manage the Recipe Center application files. You'll see how easy it is to implement code management in your project and the benefits of taking a few extra minutes to do so. Finally, we'll focus on some important files you should know about when you're running your own WAMP server. You'll discover how to keep track of who's using your Web server and how to spot errors and hackers.

Or, click the Enroll Now button below:

Student Reviews:

• "Fantastic course, Rich -- many thanks! Great teaching approach for those of us without a coding background, very non-threatening & encouraging."
  
  
• "I can't say enough good things about this course and the instructor. As a 42+ year veteran of the 'computer wars' I've had a lot of training - this was quite possibly the best ever. My web site is up and running and I already have plans to leverage this new knowledge both at work and for a little project I've had in mind for a business I run out of my home. Heartiest congratulations to everyone for such a great offering!"
  
  
• "I have taken other ed2go courses, and this one is one of the best. The material was well-prepared, the assignments were relevant and did good job of strengthening the information taught in the lessons. Richard is very interactive in the discussion area, responds quickly and completely to questions, and is willing to research and answer questions outside of direct scope of the lesson. Very good teaching style, and an excellent instructor. I am looking forward to the Intermediate course."
  
  
• "I've taken several online courses and I would rate this course one of the best. The instructor was very knowledgeable and responsive. Thanks."
  
  
• "I was impressed right away with how our instructor wrote personal replies to our introductions in the discussion area. The written materials were excellent. The course was a good all-around start to setting up an easily-updated web site. I appreciated getting information that is not always included in a course like this -- in particular versioning information and database backups. I would definitely take another class from Rich and from Ed2Go. I've already recommended another class to a friend. Thanks."
  
  
• "Richard is an excellent, patient instructor. He took time in the discussion area to completely answer questions no matter how many times information had to be repeated. I would definitely consider taking any course that he teaches. I will be watching for a PHP Level 2 course and hope it won't take too long for it to be available!"
  
  
• "The instructor was helpful and courteous, going out of his way to answer questions about the material that may not have been relevant to the class itself. I would definitely recommend others take this instructor's courses."
  
  
• "This is one of the best courses I have taken from ed2go. The course plan and the material covered helped me gain a good understanding of the subject. The assignments were very helpful. The teacher was good at communicating and answering questions."
  
  
• "When I enrolled in this course, I'd just received a refund from another school for a PHP course that fell sharply below my expectations in examples and hands-on application. I could hardly believe this course offered so much, but I'm now convinced I got everything the course said I would and more. This course was excellent in text, instruction, and hands-on applications!"
  
  

Recommended Courses:

Students who enrolled in Introduction to PHP and MySQL also enjoyed the following courses:

• Introduction to ASP.NET
  
  
• Introduction to Database Development
  
  
• Introduction to Linux
  
  
• Introduction to Perl Programming
  
  
• Introduction to PHP and MySQL
  
  
• Intermediate Java Programming
  
  
• Introduction to PHP and MySQL
  
  
• Introduction to SQL
  
  
• Introduction to CSS and XHTML
  
  
• Creating Web Pages II
  
  
• Creating Web Pages
  
  

Or, click the Enroll Now button below:

Other Subject Areas:
Computers | Writing/Language | Business/Careers | Grants/Nonprofits | Personal | Professional